from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class EquityInfo(Base):
    __tablename__ = "TYC_MR_EQUITY_INFO"
    PLEDGEELIST	= Column(Text)
    REGDATE	= Column(Integer)
    PLEDGOR	= Column(String(255))
    CERTIFNUMBERR	= Column(String(20))
    PLEDGEE	= Column(String(255))
    REGNUMBER	= Column(String(50))
    CERTIFNUMBER	= Column(String(20))
    COMPANYLIST	= Column(Text)
    TARGETCOMPANY	= Column(Text)
    PLEDGORLIST	= Column(Text)
    EQUITYAMOUNT	= Column(String(20))
    ID	= Column(Integer,primary_key=True)
    STATE	= Column(String(31))
    PUTDATE	= Column(Integer)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)